﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="LANSUNERPDataSet" targetNamespace="http://tempuri.org/LANSUNERPDataSet.xsd" xmlns:mstns="http://tempuri.org/LANSUNERPDataSet.xsd" xmlns="http://tempuri.org/LANSUNERPDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="LANSUNERPConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="LANSUNERPConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.LanSunStudio.DataBase.Properties.Settings.GlobalReference.Default.LANSUNERPConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AccountTypeTableAdapter" GeneratorDataComponentClassName="AccountTypeTableAdapter" Name="AccountType" UserDataComponentName="AccountTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LANSUNERPConnectionString (Settings)" DbObjectName="LANSUNERP.dbo.AccountType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[AccountType] WHERE (([SysID] = @Original_SysID) AND ([KeyDefType] = @Original_KeyDefType) AND ([GoodsTypeKey] = @Original_GoodsTypeKey) AND ([GoodsTypeKeyDefKey] = @Original_GoodsTypeKeyDefKey) AND ([GoodsKey] = @Original_GoodsKey) AND ((@IsNull_GoodsKeyID = 1 AND [GoodsKeyID] IS NULL) OR ([GoodsKeyID] = @Original_GoodsKeyID)) AND ((@IsNull_AccountTypeKey = 1 AND [AccountTypeKey] IS NULL) OR ([AccountTypeKey] = @Original_AccountTypeKey)) AND ((@IsNull_AccountTypeID = 1 AND [AccountTypeID] IS NULL) OR ([AccountTypeID] = @Original_AccountTypeID)) AND ((@IsNull_LongDes = 1 AND [LongDes] IS NULL) OR ([LongDes] = @Original_LongDes)) AND ((@IsNull_ShortDes = 1 AND [ShortDes] IS NULL) OR ([ShortDes] = @Original_ShortDes)) AND ((@IsNull_ExtenedProperty = 1 AND [ExtenedProperty] IS NULL) OR ([ExtenedProperty] = @Original_ExtenedProperty)) AND ((@IsNull_PositionID = 1 AND [PositionID] IS NULL) OR ([PositionID] = @Original_PositionID)) AND ((@IsNull_LastPositionID = 1 AND [LastPositionID] IS NULL) OR ([LastPositionID] = @Original_LastPositionID)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_FrstUser = 1 AND [FrstUser] IS NULL) OR ([FrstUser] = @Original_FrstUser)) AND ((@IsNull_FrstDate = 1 AND [FrstDate] IS NULL) OR ([FrstDate] = @Original_FrstDate)) AND ((@IsNull_LastUser = 1 AND [LastUser] IS NULL) OR ([LastUser] = @Original_LastUser)) AND ((@IsNull_LastDate = 1 AND [LastDate] IS NULL) OR ([LastDate] = @Original_LastDate)) AND ((@IsNull_InstanceID = 1 AND [InstanceID] IS NULL) OR ([InstanceID] = @Original_InstanceID)) AND ((@IsNull_InstanceKey = 1 AND [InstanceKey] IS NULL) OR ([InstanceKey] = @Original_InstanceKey)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SysID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SysID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_KeyDefType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeyDefType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GoodsTypeKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsTypeKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GoodsTypeKeyDefKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsTypeKeyDefKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GoodsKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GoodsKeyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GoodsKeyID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GoodsKeyID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsKeyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccountTypeKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountTypeKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AccountTypeKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccountTypeKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccountTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AccountTypeID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccountTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LongDes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LongDes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LongDes" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LongDes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShortDes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShortDes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ShortDes" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShortDes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ExtenedProperty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ExtenedProperty" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ExtenedProperty" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ExtenedProperty" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PositionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PositionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PositionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PositionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastPositionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastPositionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LastPositionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastPositionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FrstUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FrstUser" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FrstUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrstUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FrstDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FrstDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_FrstDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FrstDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastUser" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LastUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InstanceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstanceID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InstanceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InstanceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InstanceKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstanceKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InstanceKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InstanceKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[AccountType] ([SysID], [KeyDefType], [GoodsTypeKey], [GoodsTypeKeyDefKey], [GoodsKey], [GoodsKeyID], [AccountTypeKey], [AccountTypeID], [LongDes], [ShortDes], [ExtenedProperty], [PositionID], [LastPositionID], [SubStatus], [Status], [FrstUser], [FrstDate], [LastUser], [LastDate], [InstanceID], [InstanceKey]) VALUES (@SysID, @KeyDefType, @GoodsTypeKey, @GoodsTypeKeyDefKey, @GoodsKey, @GoodsKeyID, @AccountTypeKey, @AccountTypeID, @LongDes, @ShortDes, @ExtenedProperty, @PositionID, @LastPositionID, @SubStatus, @Status, @FrstUser, @FrstDate, @LastUser, @LastDate, @InstanceID, @InstanceKey);
SELECT SysID, KeyDefType, GoodsTypeKey, GoodsTypeKeyDefKey, GoodsKey, GoodsKeyID, AccountTypeKey, AccountTypeID, LongDes, ShortDes, ExtenedProperty, PositionID, LastPositionID, SubStatus, Status, FrstUser, FrstDate, LastUser, LastDate, InstanceID, InstanceKey FROM AccountType WHERE (GoodsKey = @GoodsKey) AND (GoodsTypeKey = @GoodsTypeKey) AND (GoodsTypeKeyDefKey = @GoodsTypeKeyDefKey) AND (KeyDefType = @KeyDefType) AND (SysID = @SysID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SysID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SysID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KeyDefType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeyDefType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoodsTypeKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsTypeKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoodsTypeKeyDefKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsTypeKeyDefKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoodsKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoodsKeyID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsKeyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccountTypeKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccountTypeKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccountTypeID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccountTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LongDes" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LongDes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShortDes" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShortDes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ExtenedProperty" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ExtenedProperty" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PositionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PositionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LastPositionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastPositionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SubStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SubStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FrstUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrstUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FrstDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FrstDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InstanceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InstanceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InstanceKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InstanceKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SysID, KeyDefType, GoodsTypeKey, GoodsTypeKeyDefKey, GoodsKey, GoodsKeyID, AccountTypeKey, AccountTypeID, LongDes, ShortDes, ExtenedProperty, PositionID, LastPositionID, SubStatus, Status, FrstUser, FrstDate, LastUser, LastDate, InstanceID, InstanceKey FROM dbo.AccountType</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[AccountType] SET [SysID] = @SysID, [KeyDefType] = @KeyDefType, [GoodsTypeKey] = @GoodsTypeKey, [GoodsTypeKeyDefKey] = @GoodsTypeKeyDefKey, [GoodsKey] = @GoodsKey, [GoodsKeyID] = @GoodsKeyID, [AccountTypeKey] = @AccountTypeKey, [AccountTypeID] = @AccountTypeID, [LongDes] = @LongDes, [ShortDes] = @ShortDes, [ExtenedProperty] = @ExtenedProperty, [PositionID] = @PositionID, [LastPositionID] = @LastPositionID, [SubStatus] = @SubStatus, [Status] = @Status, [FrstUser] = @FrstUser, [FrstDate] = @FrstDate, [LastUser] = @LastUser, [LastDate] = @LastDate, [InstanceID] = @InstanceID, [InstanceKey] = @InstanceKey WHERE (([SysID] = @Original_SysID) AND ([KeyDefType] = @Original_KeyDefType) AND ([GoodsTypeKey] = @Original_GoodsTypeKey) AND ([GoodsTypeKeyDefKey] = @Original_GoodsTypeKeyDefKey) AND ([GoodsKey] = @Original_GoodsKey) AND ((@IsNull_GoodsKeyID = 1 AND [GoodsKeyID] IS NULL) OR ([GoodsKeyID] = @Original_GoodsKeyID)) AND ((@IsNull_AccountTypeKey = 1 AND [AccountTypeKey] IS NULL) OR ([AccountTypeKey] = @Original_AccountTypeKey)) AND ((@IsNull_AccountTypeID = 1 AND [AccountTypeID] IS NULL) OR ([AccountTypeID] = @Original_AccountTypeID)) AND ((@IsNull_LongDes = 1 AND [LongDes] IS NULL) OR ([LongDes] = @Original_LongDes)) AND ((@IsNull_ShortDes = 1 AND [ShortDes] IS NULL) OR ([ShortDes] = @Original_ShortDes)) AND ((@IsNull_ExtenedProperty = 1 AND [ExtenedProperty] IS NULL) OR ([ExtenedProperty] = @Original_ExtenedProperty)) AND ((@IsNull_PositionID = 1 AND [PositionID] IS NULL) OR ([PositionID] = @Original_PositionID)) AND ((@IsNull_LastPositionID = 1 AND [LastPositionID] IS NULL) OR ([LastPositionID] = @Original_LastPositionID)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_FrstUser = 1 AND [FrstUser] IS NULL) OR ([FrstUser] = @Original_FrstUser)) AND ((@IsNull_FrstDate = 1 AND [FrstDate] IS NULL) OR ([FrstDate] = @Original_FrstDate)) AND ((@IsNull_LastUser = 1 AND [LastUser] IS NULL) OR ([LastUser] = @Original_LastUser)) AND ((@IsNull_LastDate = 1 AND [LastDate] IS NULL) OR ([LastDate] = @Original_LastDate)) AND ((@IsNull_InstanceID = 1 AND [InstanceID] IS NULL) OR ([InstanceID] = @Original_InstanceID)) AND ((@IsNull_InstanceKey = 1 AND [InstanceKey] IS NULL) OR ([InstanceKey] = @Original_InstanceKey)));
SELECT SysID, KeyDefType, GoodsTypeKey, GoodsTypeKeyDefKey, GoodsKey, GoodsKeyID, AccountTypeKey, AccountTypeID, LongDes, ShortDes, ExtenedProperty, PositionID, LastPositionID, SubStatus, Status, FrstUser, FrstDate, LastUser, LastDate, InstanceID, InstanceKey FROM AccountType WHERE (GoodsKey = @GoodsKey) AND (GoodsTypeKey = @GoodsTypeKey) AND (GoodsTypeKeyDefKey = @GoodsTypeKeyDefKey) AND (KeyDefType = @KeyDefType) AND (SysID = @SysID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SysID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SysID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KeyDefType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeyDefType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoodsTypeKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsTypeKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoodsTypeKeyDefKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsTypeKeyDefKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoodsKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoodsKeyID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsKeyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccountTypeKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccountTypeKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccountTypeID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccountTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LongDes" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LongDes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShortDes" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShortDes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ExtenedProperty" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ExtenedProperty" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PositionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PositionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LastPositionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastPositionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SubStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SubStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FrstUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrstUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FrstDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FrstDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InstanceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InstanceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InstanceKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InstanceKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SysID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SysID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_KeyDefType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeyDefType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GoodsTypeKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsTypeKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GoodsTypeKeyDefKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsTypeKeyDefKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GoodsKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GoodsKeyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GoodsKeyID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GoodsKeyID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GoodsKeyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccountTypeKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountTypeKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AccountTypeKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccountTypeKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccountTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AccountTypeID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccountTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LongDes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LongDes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LongDes" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LongDes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShortDes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShortDes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ShortDes" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShortDes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ExtenedProperty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ExtenedProperty" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ExtenedProperty" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ExtenedProperty" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PositionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PositionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PositionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PositionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastPositionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastPositionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LastPositionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastPositionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FrstUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FrstUser" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FrstUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrstUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FrstDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FrstDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_FrstDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FrstDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastUser" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LastUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InstanceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstanceID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InstanceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InstanceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InstanceKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstanceKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InstanceKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InstanceKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SysID" DataSetColumn="SysID" />
              <Mapping SourceColumn="KeyDefType" DataSetColumn="KeyDefType" />
              <Mapping SourceColumn="GoodsTypeKey" DataSetColumn="GoodsTypeKey" />
              <Mapping SourceColumn="GoodsTypeKeyDefKey" DataSetColumn="GoodsTypeKeyDefKey" />
              <Mapping SourceColumn="GoodsKey" DataSetColumn="GoodsKey" />
              <Mapping SourceColumn="GoodsKeyID" DataSetColumn="GoodsKeyID" />
              <Mapping SourceColumn="AccountTypeKey" DataSetColumn="AccountTypeKey" />
              <Mapping SourceColumn="AccountTypeID" DataSetColumn="AccountTypeID" />
              <Mapping SourceColumn="LongDes" DataSetColumn="LongDes" />
              <Mapping SourceColumn="ShortDes" DataSetColumn="ShortDes" />
              <Mapping SourceColumn="ExtenedProperty" DataSetColumn="ExtenedProperty" />
              <Mapping SourceColumn="PositionID" DataSetColumn="PositionID" />
              <Mapping SourceColumn="LastPositionID" DataSetColumn="LastPositionID" />
              <Mapping SourceColumn="SubStatus" DataSetColumn="SubStatus" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="FrstUser" DataSetColumn="FrstUser" />
              <Mapping SourceColumn="FrstDate" DataSetColumn="FrstDate" />
              <Mapping SourceColumn="LastUser" DataSetColumn="LastUser" />
              <Mapping SourceColumn="LastDate" DataSetColumn="LastDate" />
              <Mapping SourceColumn="InstanceID" DataSetColumn="InstanceID" />
              <Mapping SourceColumn="InstanceKey" DataSetColumn="InstanceKey" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="LANSUNERPDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="LANSUNERPDataSet" msprop:Generator_UserDSName="LANSUNERPDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="AccountType" msprop:Generator_TableClassName="AccountTypeDataTable" msprop:Generator_TableVarName="tableAccountType" msprop:Generator_TablePropName="AccountType" msprop:Generator_RowDeletingName="AccountTypeRowDeleting" msprop:Generator_UserTableName="AccountType" msprop:Generator_RowChangingName="AccountTypeRowChanging" msprop:Generator_RowEvHandlerName="AccountTypeRowChangeEventHandler" msprop:Generator_RowDeletedName="AccountTypeRowDeleted" msprop:Generator_RowEvArgName="AccountTypeRowChangeEvent" msprop:Generator_RowChangedName="AccountTypeRowChanged" msprop:Generator_RowClassName="AccountTypeRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SysID" msprop:Generator_ColumnVarNameInTable="columnSysID" msprop:Generator_ColumnPropNameInRow="SysID" msprop:Generator_ColumnPropNameInTable="SysIDColumn" msprop:Generator_UserColumnName="SysID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="KeyDefType" msprop:Generator_ColumnVarNameInTable="columnKeyDefType" msprop:Generator_ColumnPropNameInRow="KeyDefType" msprop:Generator_ColumnPropNameInTable="KeyDefTypeColumn" msprop:Generator_UserColumnName="KeyDefType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GoodsTypeKey" msprop:Generator_ColumnVarNameInTable="columnGoodsTypeKey" msprop:Generator_ColumnPropNameInRow="GoodsTypeKey" msprop:Generator_ColumnPropNameInTable="GoodsTypeKeyColumn" msprop:Generator_UserColumnName="GoodsTypeKey">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GoodsTypeKeyDefKey" msprop:Generator_ColumnVarNameInTable="columnGoodsTypeKeyDefKey" msprop:Generator_ColumnPropNameInRow="GoodsTypeKeyDefKey" msprop:Generator_ColumnPropNameInTable="GoodsTypeKeyDefKeyColumn" msprop:Generator_UserColumnName="GoodsTypeKeyDefKey">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GoodsKey" msprop:Generator_ColumnVarNameInTable="columnGoodsKey" msprop:Generator_ColumnPropNameInRow="GoodsKey" msprop:Generator_ColumnPropNameInTable="GoodsKeyColumn" msprop:Generator_UserColumnName="GoodsKey">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GoodsKeyID" msprop:Generator_ColumnVarNameInTable="columnGoodsKeyID" msprop:Generator_ColumnPropNameInRow="GoodsKeyID" msprop:Generator_ColumnPropNameInTable="GoodsKeyIDColumn" msprop:Generator_UserColumnName="GoodsKeyID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccountTypeKey" msprop:Generator_ColumnVarNameInTable="columnAccountTypeKey" msprop:Generator_ColumnPropNameInRow="AccountTypeKey" msprop:Generator_ColumnPropNameInTable="AccountTypeKeyColumn" msprop:Generator_UserColumnName="AccountTypeKey" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccountTypeID" msprop:Generator_ColumnVarNameInTable="columnAccountTypeID" msprop:Generator_ColumnPropNameInRow="AccountTypeID" msprop:Generator_ColumnPropNameInTable="AccountTypeIDColumn" msprop:Generator_UserColumnName="AccountTypeID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LongDes" msprop:Generator_ColumnVarNameInTable="columnLongDes" msprop:Generator_ColumnPropNameInRow="LongDes" msprop:Generator_ColumnPropNameInTable="LongDesColumn" msprop:Generator_UserColumnName="LongDes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShortDes" msprop:Generator_ColumnVarNameInTable="columnShortDes" msprop:Generator_ColumnPropNameInRow="ShortDes" msprop:Generator_ColumnPropNameInTable="ShortDesColumn" msprop:Generator_UserColumnName="ShortDes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ExtenedProperty" msprop:Generator_ColumnVarNameInTable="columnExtenedProperty" msprop:Generator_ColumnPropNameInRow="ExtenedProperty" msprop:Generator_ColumnPropNameInTable="ExtenedPropertyColumn" msprop:Generator_UserColumnName="ExtenedProperty" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PositionID" msprop:Generator_ColumnVarNameInTable="columnPositionID" msprop:Generator_ColumnPropNameInRow="PositionID" msprop:Generator_ColumnPropNameInTable="PositionIDColumn" msprop:Generator_UserColumnName="PositionID" type="xs:int" minOccurs="0" />
              <xs:element name="LastPositionID" msprop:Generator_ColumnVarNameInTable="columnLastPositionID" msprop:Generator_ColumnPropNameInRow="LastPositionID" msprop:Generator_ColumnPropNameInTable="LastPositionIDColumn" msprop:Generator_UserColumnName="LastPositionID" type="xs:int" minOccurs="0" />
              <xs:element name="SubStatus" msprop:Generator_ColumnVarNameInTable="columnSubStatus" msprop:Generator_ColumnPropNameInRow="SubStatus" msprop:Generator_ColumnPropNameInTable="SubStatusColumn" msprop:Generator_UserColumnName="SubStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_UserColumnName="Status" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FrstUser" msprop:Generator_ColumnVarNameInTable="columnFrstUser" msprop:Generator_ColumnPropNameInRow="FrstUser" msprop:Generator_ColumnPropNameInTable="FrstUserColumn" msprop:Generator_UserColumnName="FrstUser" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FrstDate" msprop:Generator_ColumnVarNameInTable="columnFrstDate" msprop:Generator_ColumnPropNameInRow="FrstDate" msprop:Generator_ColumnPropNameInTable="FrstDateColumn" msprop:Generator_UserColumnName="FrstDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="LastUser" msprop:Generator_ColumnVarNameInTable="columnLastUser" msprop:Generator_ColumnPropNameInRow="LastUser" msprop:Generator_ColumnPropNameInTable="LastUserColumn" msprop:Generator_UserColumnName="LastUser" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastDate" msprop:Generator_ColumnVarNameInTable="columnLastDate" msprop:Generator_ColumnPropNameInRow="LastDate" msprop:Generator_ColumnPropNameInTable="LastDateColumn" msprop:Generator_UserColumnName="LastDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="InstanceID" msprop:Generator_ColumnVarNameInTable="columnInstanceID" msprop:Generator_ColumnPropNameInRow="InstanceID" msprop:Generator_ColumnPropNameInTable="InstanceIDColumn" msprop:Generator_UserColumnName="InstanceID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InstanceKey" msprop:Generator_ColumnVarNameInTable="columnInstanceKey" msprop:Generator_ColumnPropNameInRow="InstanceKey" msprop:Generator_ColumnPropNameInTable="InstanceKeyColumn" msprop:Generator_UserColumnName="InstanceKey" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:AccountType" />
      <xs:field xpath="mstns:SysID" />
      <xs:field xpath="mstns:KeyDefType" />
      <xs:field xpath="mstns:GoodsTypeKey" />
      <xs:field xpath="mstns:GoodsTypeKeyDefKey" />
      <xs:field xpath="mstns:GoodsKey" />
    </xs:unique>
  </xs:element>
</xs:schema>